<?php

/* * ************************************************************************************************
  |
  | AudioShare - Audio Sharing Script
  | http://www.audiosharescript.com
  | webmaster@audiosharescript.com
  |
  |**************************************************************************************************
  |
  | By using this software you agree that you have read and acknowledged our End-User License
  | Agreement available at http://www.audiosharescript.com/eula.html and to be bound by it.
  |
  | Copyright (c) 2010 AudioShareScript.com. All rights reserved.
  |************************************************************************************************* */

include("include/config.php");
include("include/functions/import.php");
$thebaseurl = $config['baseurl'];

$mainmenu = "8";
STemplate::assign('mainmenu', $mainmenu);


//Get Variables
$getsortby = htmlentities(strip_tags($_REQUEST[sortby]));
$sortby = escape($getsortby);
$getfilter = htmlentities(strip_tags($_REQUEST[filter]));
$filter = escape($getfilter);
$getpage = htmlentities(strip_tags($_REQUEST[page]));
$page = escape($getpage);

if ($sortby == "a") {
    $sort = "asc";
} else {
    $sortby = "z";
    $sort = "desc";
}

if ($page == "") {
    $page = "1";
}
$currentpage = $page;

if ($page >= 2) {
    $pagingstart = ($page - 1) * $config[items_per_page];
} else {
    $pagingstart = "0";
}

if (strlen($filter) >= 4) {
    //Ensures no input longer than 4 characters is specified as a category id
} else {
//echo $config[items_per_page]=1;
    $query1 = "SELECT count(*) as total from audios where categories='" . mysql_real_escape_string($filter) . "' AND public='1' AND active='1' order by time_added $sort limit $config[maximum_results]";
    $query2 = "SELECT * from audios where categories='" . mysql_real_escape_string($filter) . "' AND public='1' AND active='1' order by time_added $sort limit $pagingstart, $config[items_per_page]";
    $query4 = "SELECT name FROM categories_audios WHERE CATID='" . mysql_real_escape_string($filter) . "'";
    $executequery4 = $conn->execute($query4);
    $getcategoryname = $executequery4->fields[name];
}
$showtitle = $getcategoryname . " $lang[796]";
$showseotitle = $getcategoryname;

STemplate::assign('showtitle', $showtitle);
STemplate::assign('pagetitle', $showtitle);
STemplate::assign('showseotitle', $showseotitle);
STemplate::assign('filter', $filter);

$executequery1 = $conn->Execute($query1);

$totalaudios = $executequery1->fields['total'];
if ($totalaudios > 0) {

    if ($executequery1->fields['total'] <= $config[maximum_results]) {
        $total = $executequery1->fields['total'];
    } else {
        $total = $config[maximum_results];
    }

    $toppage = ceil($total / $config[items_per_page]);
    if ($toppage == 0) {
        $xpage = $toppage + 1;
    } else {
        $xpage = $toppage;
    }


    $executequery2 = $conn->Execute($query2);
    $users = $executequery2->getrows();
    $beginning = $pagingstart + 1;
    $ending = $pagingstart + $executequery2->recordcount();

    $pagelinks = "";
    $k = 1;
    $theprevpage = $currentpage - 1;
    $thenextpage = $currentpage + 1;

    if ($currentpage > 0) {
        ## paging starts here...

        $pagelinks.='<table width="100%" cellspacing="2" cellpadding="2" border="0">';
        $pagelinks.='<tr>';
        $pagelinks.='<td width="33%">';
        $pagelinks.='<a href="javascript:void(0);"><img height="16" width="16" border="0" align="absmiddle" src="' . $config[imageurl] . '/ico_rss_s.gif" alt="RSS"  /></a>';
        $pagelinks.='<span class="pag"> page ' . $currentpage . ' of ' . $total . '</span>';
        $pagelinks.='</td>';
        $pagelinks.='<td width="33%" align="right">';
        $pagelinks.="<div class=\"pagination\">";
        if ($currentpage > 1) {
            $pagelinks.="<a href='$thebaseurl/browse/categories/audios/$sortby/$filter/1/$showseotitle'>$lang[611]</a>";
            $pagelinks.="<span class='ellipsis'>...</span>";
            $pagelinks.="<a href='$thebaseurl/browse/categories/audios/$sortby/$filter/$theprevpage/$showseotitle'>&laquo; $lang[612]</a>";
        } else {
            $pagelinks.="<span>&lt;</span>";
        }
        $counter = 0;
        $lowercount = $currentpage - 5;
        if ($lowercount <= 0)
            $lowercount = 1;

        while ($lowercount < $currentpage) {
            $pagelinks.="<a href='$thebaseurl/browse/categories/audios/$sortby/$filter/$lowercount/$showseotitle'>$lowercount</a>";
            $lowercount++;
            $counter++;
        }

        $pagelinks.="<span class='current'><span>$currentpage</span></span>";

        $uppercounter = $currentpage + 1;

        while (($uppercounter < $currentpage + 10 - $counter) && ($uppercounter <= $toppage)) {
            $pagelinks.="<a href='$thebaseurl/browse/categories/audios/$sortby/$filter/$uppercounter/$showseotitle'>$uppercounter</a>";
            $uppercounter++;
        }

        if ($currentpage < $toppage) {
            $pagelinks.="<a href='$thebaseurl/browse/categories/audios/$sortby/$filter/$thenextpage/$showseotitle'>$lang[613] &raquo;</a>";
            $pagelinks.="<span class='ellipsis'>...</span>";
            $pagelinks.="<a href='$thebaseurl/browse/categories/audios/$sortby/$filter/$toppage/$showseotitle'>$lang[614]</a>";
        } else {
            $pagelinks.="<span class=\"disable\">&gt;</span>";
        }
        $pagelinks.="</div>";
        $pagelinks.='</td>';
        $pagelinks.='</tr>';
        $pagelinks.="</table>";
        ## paging ends here
    }
} else {
    $error = "$lang[812]";
    STemplate::assign('error', $error);
}

//TEMPLATES BEGIN
STemplate::assign('beginning', $beginning);
STemplate::assign('ending', $ending);
STemplate::assign('pagelinks', $pagelinks);
STemplate::assign('total', $total);
STemplate::assign('listaudios', $users);
STemplate::display('header.tpl');
STemplate::display('categoryaudios.tpl');
STemplate::display('footer.tpl');
//TEMPLATES END
?>